package com.busi.wms.model;

import java.util.Map;

import com.jfinal.plugin.activerecord.Model;
import com.zcurd.common.tool.DbMetaTool;

public class WmsLocation extends Model<WmsLocation> {
	private static final long serialVersionUID = 1L;
	public static final WmsLocation me = new WmsLocation();
		
	public Map<String, Object> getDictDatastorage_no() {
		return DbMetaTool.getDictData("select cast(id as varchar) 'key',storage_name 'text' from [cquni-wms].dbo.wms_storage");
	}	
		
	public Map<String, Object> getDictDataLoc_type() {
		return DbMetaTool.getDictData("select '0' 'key', '非标准库位' 'text' union all select '1', '标准库位'");
	}	
		
	public Map<String, Object> getDictDatais_use() {
		return DbMetaTool.getDictData("select '0' 'key', '停用' 'text' union all select '1', '正常'");
	}	
	
}
